USE [vudu]
GO
/****** Object:  StoredProcedure [dbo].[SeccionMateria]    Script Date: 05/27/2011 05:38:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[ConsultaSeccionMateria] 
	@seccion int

AS
BEGIN

	SET NOCOUNT ON;
	SELECT numeroSeccion as seccion,fk_Profesor as idprofesor,fk_Materia  as idmateria
    FROM [vudu].[dbo].[SeccionMateria] 
    WHERE id_Seccion = @seccion
    
END
